﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="modconDataSet" targetNamespace="http://tempuri.org/modconDataSet.xsd" xmlns:mstns="http://tempuri.org/modconDataSet.xsd" xmlns="http://tempuri.org/modconDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="modconConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="modconConnectionString (Settings)" PropertyReference="ApplicationSettings.TISS_Add_in.Properties.Settings.GlobalReference.Default.modconConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Clin_HospTableAdapter" GeneratorDataComponentClassName="Clin_HospTableAdapter" Name="Clin_Hosp" UserDataComponentName="Clin_HospTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Clin_Hosp" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Clin_Hosp` WHERE ((`ID` = ?) AND ((? = 1 AND `CNES` IS NULL) OR (`CNES` = ?)) AND ((? = 1 AND `CNPJ` IS NULL) OR (`CNPJ` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CNES" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CNES" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CNPJ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CNPJ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Clin_Hosp` (`ID`, `CNES`, `CNPJ`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CNES" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CNPJ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, CNES, CNPJ FROM Clin_Hosp</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Clin_Hosp` SET `ID` = ?, `CNES` = ?, `CNPJ` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `CNES` IS NULL) OR (`CNES` = ?)) AND ((? = 1 AND `CNPJ` IS NULL) OR (`CNPJ` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CNES" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CNPJ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CNES" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CNES" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CNPJ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CNPJ" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CNPJ" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="CNES" DataSetColumn="CNES" />
              <Mapping SourceColumn="CNPJ" DataSetColumn="CNPJ" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DemonstrativoRetornoTableAdapter" GeneratorDataComponentClassName="DemonstrativoRetornoTableAdapter" Name="DemonstrativoRetorno" UserDataComponentName="DemonstrativoRetornoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="DemonstrativoRetorno" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `DemonstrativoRetorno` WHERE ((`demonstrativoCod` = ?) AND ((? = 1 AND `tipoSolic_Cod` IS NULL) OR (`tipoSolic_Cod` = ?)) AND ((? = 1 AND `SequencialTransacao` IS NULL) OR (`SequencialTransacao` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)) AND ((? = 1 AND `loteID` IS NULL) OR (`loteID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_demonstrativoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="demonstrativoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoSolic_Cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoSolic_Cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `DemonstrativoRetorno` (`tipoSolic_Cod`, `SequencialTransacao`, `codPrestador`, `regANS`, `loteID`, `demonstrativo`) VALUES (?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoSolic_Cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="demonstrativo" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="demonstrativo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT demonstrativoCod, tipoSolic_Cod, SequencialTransacao, codPrestador, regANS, loteID, demonstrativo FROM DemonstrativoRetorno</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `DemonstrativoRetorno` SET `tipoSolic_Cod` = ?, `SequencialTransacao` = ?, `codPrestador` = ?, `regANS` = ?, `loteID` = ?, `demonstrativo` = ? WHERE ((`demonstrativoCod` = ?) AND ((? = 1 AND `tipoSolic_Cod` IS NULL) OR (`tipoSolic_Cod` = ?)) AND ((? = 1 AND `SequencialTransacao` IS NULL) OR (`SequencialTransacao` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)) AND ((? = 1 AND `loteID` IS NULL) OR (`loteID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoSolic_Cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="demonstrativo" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="demonstrativo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_demonstrativoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="demonstrativoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoSolic_Cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoSolic_Cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_Cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_loteID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="loteID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="demonstrativoCod" DataSetColumn="demonstrativoCod" />
              <Mapping SourceColumn="tipoSolic_Cod" DataSetColumn="tipoSolic_Cod" />
              <Mapping SourceColumn="SequencialTransacao" DataSetColumn="SequencialTransacao" />
              <Mapping SourceColumn="codPrestador" DataSetColumn="codPrestador" />
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
              <Mapping SourceColumn="loteID" DataSetColumn="loteID" />
              <Mapping SourceColumn="demonstrativo" DataSetColumn="demonstrativo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExtensaoSolicProcTableAdapter" GeneratorDataComponentClassName="ExtensaoSolicProcTableAdapter" Name="ExtensaoSolicProc" UserDataComponentName="ExtensaoSolicProcTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="ExtensaoSolicProc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ExtensaoSolicProc` WHERE ((`ID` = ?) AND ((? = 1 AND `numeroGuia` IS NULL) OR (`numeroGuia` = ?)) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ExtensaoSolicProc` (`numeroGuia`, `local`, `codPrestador`, `regANS`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, numeroGuia, [local], codPrestador, regANS FROM ExtensaoSolicProc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ExtensaoSolicProc` SET `numeroGuia` = ?, `local` = ?, `codPrestador` = ?, `regANS` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `numeroGuia` IS NULL) OR (`numeroGuia` = ?)) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="numeroGuia" DataSetColumn="numeroGuia" />
              <Mapping SourceColumn="local" DataSetColumn="local" />
              <Mapping SourceColumn="codPrestador" DataSetColumn="codPrestador" />
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="guiaTableAdapter" GeneratorDataComponentClassName="guiaTableAdapter" Name="guia" UserDataComponentName="guiaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="guia" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `guia` WHERE ((`numeroGuia` = ?) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `cancelada` IS NULL) OR (`cancelada` = ?)) AND (`IDLote` = ?) AND ((? = 1 AND `dataEmissao` IS NULL) OR (`dataEmissao` = ?)) AND ((? = 1 AND `glosa` IS NULL) OR (`glosa` = ?)) AND ((? = 1 AND `reapresentada` IS NULL) OR (`reapresentada` = ?)) AND ((? = 1 AND `numeroGuiaOperadora` IS NULL) OR (`numeroGuiaOperadora` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cancelada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataEmissao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_glosa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_reapresentada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_reapresentada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuiaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `guia` (`numeroGuia`, `local`, `cancelada`, `IDLote`, `dataEmissao`, `glosa`, `reapresentada`, `numeroGuiaOperadora`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="reapresentada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT numeroGuia, [local], cancelada, IDLote, dataEmissao, glosa, reapresentada, numeroGuiaOperadora FROM guia</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `guia` SET `numeroGuia` = ?, `local` = ?, `cancelada` = ?, `IDLote` = ?, `dataEmissao` = ?, `glosa` = ?, `reapresentada` = ?, `numeroGuiaOperadora` = ? WHERE ((`numeroGuia` = ?) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `cancelada` IS NULL) OR (`cancelada` = ?)) AND (`IDLote` = ?) AND ((? = 1 AND `dataEmissao` IS NULL) OR (`dataEmissao` = ?)) AND ((? = 1 AND `glosa` IS NULL) OR (`glosa` = ?)) AND ((? = 1 AND `reapresentada` IS NULL) OR (`reapresentada` = ?)) AND ((? = 1 AND `numeroGuiaOperadora` IS NULL) OR (`numeroGuiaOperadora` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="reapresentada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cancelada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataEmissao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_glosa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_reapresentada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_reapresentada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="reapresentada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuiaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="numeroGuia" DataSetColumn="numeroGuia" />
              <Mapping SourceColumn="local" DataSetColumn="local" />
              <Mapping SourceColumn="cancelada" DataSetColumn="cancelada" />
              <Mapping SourceColumn="IDLote" DataSetColumn="IDLote" />
              <Mapping SourceColumn="dataEmissao" DataSetColumn="dataEmissao" />
              <Mapping SourceColumn="glosa" DataSetColumn="glosa" />
              <Mapping SourceColumn="reapresentada" DataSetColumn="reapresentada" />
              <Mapping SourceColumn="numeroGuiaOperadora" DataSetColumn="numeroGuiaOperadora" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="guiaOutrasDespesasTableAdapter" GeneratorDataComponentClassName="guiaOutrasDespesasTableAdapter" Name="guiaOutrasDespesas" UserDataComponentName="guiaOutrasDespesasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="guiaOutrasDespesas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `guiaOutrasDespesas` WHERE ((`ID` = ?) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `numeroGuia` IS NULL) OR (`numeroGuia` = ?)) AND ((? = 1 AND `IDLote` IS NULL) OR (`IDLote` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `guiaOutrasDespesas` (`local`, `numeroGuia`, `IDLote`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, [local], numeroGuia, IDLote FROM guiaOutrasDespesas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `guiaOutrasDespesas` SET `local` = ?, `numeroGuia` = ?, `IDLote` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND ((? = 1 AND `numeroGuia` IS NULL) OR (`numeroGuia` = ?)) AND ((? = 1 AND `IDLote` IS NULL) OR (`IDLote` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="local" DataSetColumn="local" />
              <Mapping SourceColumn="numeroGuia" DataSetColumn="numeroGuia" />
              <Mapping SourceColumn="IDLote" DataSetColumn="IDLote" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IntervaloLoteTableAdapter" GeneratorDataComponentClassName="IntervaloLoteTableAdapter" Name="IntervaloLote" UserDataComponentName="IntervaloLoteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="IntervaloLote" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `IntervaloLote` WHERE ((`ID` = ?) AND ((? = 1 AND `IDTrabalha` IS NULL) OR (`IDTrabalha` = ?)) AND ((? = 1 AND `De` IS NULL) OR (`De` = ?)) AND ((? = 1 AND `Ate` IS NULL) OR (`Ate` = ?)) AND ((? = 1 AND `Atual` IS NULL) OR (`Atual` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `IntervaloLote` (`IDTrabalha`, `De`, `Ate`, `Atual`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, IDTrabalha, De, Ate, Atual FROM IntervaloLote</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `IntervaloLote` SET `IDTrabalha` = ?, `De` = ?, `Ate` = ?, `Atual` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `IDTrabalha` IS NULL) OR (`IDTrabalha` = ?)) AND ((? = 1 AND `De` IS NULL) OR (`De` = ?)) AND ((? = 1 AND `Ate` IS NULL) OR (`Ate` = ?)) AND ((? = 1 AND `Atual` IS NULL) OR (`Atual` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDTrabalha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDTrabalha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_De" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="De" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Ate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Atual" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Atual" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IDTrabalha" DataSetColumn="IDTrabalha" />
              <Mapping SourceColumn="De" DataSetColumn="De" />
              <Mapping SourceColumn="Ate" DataSetColumn="Ate" />
              <Mapping SourceColumn="Atual" DataSetColumn="Atual" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoginTableAdapter" GeneratorDataComponentClassName="LoginTableAdapter" Name="Login" UserDataComponentName="LoginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Login" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Login` WHERE ((`ID` = ?) AND ((? = 1 AND `Usuario` IS NULL) OR (`Usuario` = ?)) AND ((? = 1 AND `Senha` IS NULL) OR (`Senha` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Usuario" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Usuario" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Senha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Senha" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Login` (`ID`, `Usuario`, `Senha`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Usuario" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Senha" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Usuario, Senha FROM Login</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Login` SET `ID` = ?, `Usuario` = ?, `Senha` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Usuario` IS NULL) OR (`Usuario` = ?)) AND ((? = 1 AND `Senha` IS NULL) OR (`Senha` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Usuario" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Senha" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Usuario" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Usuario" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Senha" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Senha" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Senha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Usuario" DataSetColumn="Usuario" />
              <Mapping SourceColumn="Senha" DataSetColumn="Senha" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LoteGuiasTableAdapter" GeneratorDataComponentClassName="LoteGuiasTableAdapter" Name="LoteGuias" UserDataComponentName="LoteGuiasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="LoteGuias" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `LoteGuias` WHERE ((`ID` = ?) AND ((? = 1 AND `numeroLote` IS NULL) OR (`numeroLote` = ?)) AND ((? = 1 AND `sequencialTransacao` IS NULL) OR (`sequencialTransacao` = ?)) AND ((? = 1 AND `protocoloRecebimento` IS NULL) OR (`protocoloRecebimento` = ?)) AND ((? = 1 AND `codStatusRecebimento` IS NULL) OR (`codStatusRecebimento` = ?)) AND ((? = 1 AND `tipoGuia` IS NULL) OR (`tipoGuia` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroLote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_protocoloRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_protocoloRecebimento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codStatusRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoGuia" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `LoteGuias` (`numeroLote`, `sequencialTransacao`, `protocoloRecebimento`, `codStatusRecebimento`, `tipoGuia`, `codPrestador`, `regANS`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroLote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="protocoloRecebimento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoGuia" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, numeroLote, sequencialTransacao, protocoloRecebimento, codStatusRecebimento, tipoGuia, codPrestador, regANS FROM LoteGuias</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `LoteGuias` SET `numeroLote` = ?, `sequencialTransacao` = ?, `protocoloRecebimento` = ?, `codStatusRecebimento` = ?, `tipoGuia` = ?, `codPrestador` = ?, `regANS` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `numeroLote` IS NULL) OR (`numeroLote` = ?)) AND ((? = 1 AND `sequencialTransacao` IS NULL) OR (`sequencialTransacao` = ?)) AND ((? = 1 AND `protocoloRecebimento` IS NULL) OR (`protocoloRecebimento` = ?)) AND ((? = 1 AND `codStatusRecebimento` IS NULL) OR (`codStatusRecebimento` = ?)) AND ((? = 1 AND `tipoGuia` IS NULL) OR (`tipoGuia` = ?)) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroLote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="protocoloRecebimento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoGuia" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroLote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_protocoloRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_protocoloRecebimento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="protocoloRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codStatusRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoGuia" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="numeroLote" DataSetColumn="numeroLote" />
              <Mapping SourceColumn="sequencialTransacao" DataSetColumn="sequencialTransacao" />
              <Mapping SourceColumn="protocoloRecebimento" DataSetColumn="protocoloRecebimento" />
              <Mapping SourceColumn="codStatusRecebimento" DataSetColumn="codStatusRecebimento" />
              <Mapping SourceColumn="tipoGuia" DataSetColumn="tipoGuia" />
              <Mapping SourceColumn="codPrestador" DataSetColumn="codPrestador" />
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MensagemTableAdapter" GeneratorDataComponentClassName="MensagemTableAdapter" Name="Mensagem" UserDataComponentName="MensagemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Mensagem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Mensagem` WHERE ((`sequencialTransacao` = ?) AND ((? = 1 AND `dataTransacao` IS NULL) OR (`dataTransacao` = ?)) AND ((? = 1 AND `tipoCod` IS NULL) OR (`tipoCod` = ?)) AND ((? = 1 AND `origem` IS NULL) OR (`origem` = ?)) AND ((? = 1 AND `destino` IS NULL) OR (`destino` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_dataTransacao" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_destino" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_destino" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Mensagem` (`dataTransacao`, `tipoCod`, `origem`, `destino`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="dataTransacao" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="destino" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT sequencialTransacao, dataTransacao, tipoCod, origem, destino FROM Mensagem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Mensagem` SET `dataTransacao` = ?, `tipoCod` = ?, `origem` = ?, `destino` = ? WHERE ((`sequencialTransacao` = ?) AND ((? = 1 AND `dataTransacao` IS NULL) OR (`dataTransacao` = ?)) AND ((? = 1 AND `tipoCod` IS NULL) OR (`tipoCod` = ?)) AND ((? = 1 AND `origem` IS NULL) OR (`origem` = ?)) AND ((? = 1 AND `destino` IS NULL) OR (`destino` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="dataTransacao" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="destino" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_dataTransacao" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dataTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_origem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="origem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_destino" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_destino" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="destino" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sequencialTransacao" DataSetColumn="sequencialTransacao" />
              <Mapping SourceColumn="dataTransacao" DataSetColumn="dataTransacao" />
              <Mapping SourceColumn="tipoCod" DataSetColumn="tipoCod" />
              <Mapping SourceColumn="origem" DataSetColumn="origem" />
              <Mapping SourceColumn="destino" DataSetColumn="destino" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OperadoraTableAdapter" GeneratorDataComponentClassName="OperadoraTableAdapter" Name="Operadora" UserDataComponentName="OperadoraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Operadora" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Operadora` WHERE ((`regANS` = ?) AND ((? = 1 AND `nome` IS NULL) OR (`nome` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_nome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Operadora` (`regANS`, `nome`, `logo`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="logo" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT regANS, nome, logo FROM Operadora</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Operadora` SET `regANS` = ?, `nome` = ?, `logo` = ? WHERE ((`regANS` = ?) AND ((? = 1 AND `nome` IS NULL) OR (`nome` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="logo" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_nome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
              <Mapping SourceColumn="nome" DataSetColumn="nome" />
              <Mapping SourceColumn="logo" DataSetColumn="logo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OperadoraURLsTableAdapter" GeneratorDataComponentClassName="OperadoraURLsTableAdapter" Name="OperadoraURLs" UserDataComponentName="OperadoraURLsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="OperadoraURLs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `OperadoraURLs` WHERE ((`regANS` = ?) AND (`tipoURL_cod` = ?) AND ((? = 1 AND `url` IS NULL) OR (`url` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_url" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_url" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `OperadoraURLs` (`regANS`, `tipoURL_cod`, `url`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="url" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT regANS, tipoURL_cod, url FROM OperadoraURLs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `OperadoraURLs` SET `regANS` = ?, `tipoURL_cod` = ?, `url` = ? WHERE ((`regANS` = ?) AND (`tipoURL_cod` = ?) AND ((? = 1 AND `url` IS NULL) OR (`url` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="url" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_url" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_url" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="url" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
              <Mapping SourceColumn="tipoURL_cod" DataSetColumn="tipoURL_cod" />
              <Mapping SourceColumn="url" DataSetColumn="url" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PrestadorTableAdapter" GeneratorDataComponentClassName="PrestadorTableAdapter" Name="Prestador" UserDataComponentName="PrestadorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Prestador" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Prestador` WHERE ((`ID` = ?) AND ((? = 1 AND `nome` IS NULL) OR (`nome` = ?)) AND ((? = 1 AND `tipoLogradouro` IS NULL) OR (`tipoLogradouro` = ?)) AND ((? = 1 AND `logradouro` IS NULL) OR (`logradouro` = ?)) AND ((? = 1 AND `numero` IS NULL) OR (`numero` = ?)) AND ((? = 1 AND `complemento` IS NULL) OR (`complemento` = ?)) AND ((? = 1 AND `codIBGEMun` IS NULL) OR (`codIBGEMun` = ?)) AND ((? = 1 AND `municipio` IS NULL) OR (`municipio` = ?)) AND ((? = 1 AND `codUF` IS NULL) OR (`codUF` = ?)) AND ((? = 1 AND `CEP` IS NULL) OR (`CEP` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_nome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoLogradouro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoLogradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_logradouro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_logradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numero" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_complemento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_complemento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codIBGEMun" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codIBGEMun" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_municipio" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_municipio" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codUF" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codUF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CEP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CEP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Prestador` (`nome`, `tipoLogradouro`, `logradouro`, `numero`, `complemento`, `codIBGEMun`, `municipio`, `codUF`, `CEP`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoLogradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="logradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="complemento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codIBGEMun" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="municipio" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codUF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CEP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, nome, tipoLogradouro, logradouro, numero, complemento, codIBGEMun, municipio, codUF, CEP FROM Prestador</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Prestador` SET `nome` = ?, `tipoLogradouro` = ?, `logradouro` = ?, `numero` = ?, `complemento` = ?, `codIBGEMun` = ?, `municipio` = ?, `codUF` = ?, `CEP` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `nome` IS NULL) OR (`nome` = ?)) AND ((? = 1 AND `tipoLogradouro` IS NULL) OR (`tipoLogradouro` = ?)) AND ((? = 1 AND `logradouro` IS NULL) OR (`logradouro` = ?)) AND ((? = 1 AND `numero` IS NULL) OR (`numero` = ?)) AND ((? = 1 AND `complemento` IS NULL) OR (`complemento` = ?)) AND ((? = 1 AND `codIBGEMun` IS NULL) OR (`codIBGEMun` = ?)) AND ((? = 1 AND `municipio` IS NULL) OR (`municipio` = ?)) AND ((? = 1 AND `codUF` IS NULL) OR (`codUF` = ?)) AND ((? = 1 AND `CEP` IS NULL) OR (`CEP` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoLogradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="logradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="complemento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codIBGEMun" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="municipio" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codUF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CEP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_nome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_nome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoLogradouro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoLogradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoLogradouro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_logradouro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_logradouro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="logradouro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numero" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numero" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_complemento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_complemento" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="complemento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codIBGEMun" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codIBGEMun" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codIBGEMun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_municipio" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_municipio" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="municipio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codUF" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codUF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CEP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CEP" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CEP" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="nome" DataSetColumn="nome" />
              <Mapping SourceColumn="tipoLogradouro" DataSetColumn="tipoLogradouro" />
              <Mapping SourceColumn="logradouro" DataSetColumn="logradouro" />
              <Mapping SourceColumn="numero" DataSetColumn="numero" />
              <Mapping SourceColumn="complemento" DataSetColumn="complemento" />
              <Mapping SourceColumn="codIBGEMun" DataSetColumn="codIBGEMun" />
              <Mapping SourceColumn="municipio" DataSetColumn="municipio" />
              <Mapping SourceColumn="codUF" DataSetColumn="codUF" />
              <Mapping SourceColumn="CEP" DataSetColumn="CEP" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProfissionalTableAdapter" GeneratorDataComponentClassName="ProfissionalTableAdapter" Name="Profissional" UserDataComponentName="ProfissionalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Profissional" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Profissional` WHERE ((`ID` = ?) AND ((? = 1 AND `siglaConselho` IS NULL) OR (`siglaConselho` = ?)) AND ((? = 1 AND `numeroConselho` IS NULL) OR (`numeroConselho` = ?)) AND ((? = 1 AND `ufConselho` IS NULL) OR (`ufConselho` = ?)) AND ((? = 1 AND `CPF` IS NULL) OR (`CPF` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_siglaConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_siglaConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ufConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ufConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CPF" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CPF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Profissional` (`ID`, `siglaConselho`, `numeroConselho`, `ufConselho`, `CPF`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="siglaConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ufConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CPF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, siglaConselho, numeroConselho, ufConselho, CPF FROM Profissional</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Profissional` SET `ID` = ?, `siglaConselho` = ?, `numeroConselho` = ?, `ufConselho` = ?, `CPF` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `siglaConselho` IS NULL) OR (`siglaConselho` = ?)) AND ((? = 1 AND `numeroConselho` IS NULL) OR (`numeroConselho` = ?)) AND ((? = 1 AND `ufConselho` IS NULL) OR (`ufConselho` = ?)) AND ((? = 1 AND `CPF` IS NULL) OR (`CPF` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="siglaConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ufConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CPF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_siglaConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_siglaConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="siglaConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ufConselho" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ufConselho" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ufConselho" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CPF" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CPF" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CPF" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="siglaConselho" DataSetColumn="siglaConselho" />
              <Mapping SourceColumn="numeroConselho" DataSetColumn="numeroConselho" />
              <Mapping SourceColumn="ufConselho" DataSetColumn="ufConselho" />
              <Mapping SourceColumn="CPF" DataSetColumn="CPF" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SolicitacaoProcedimentoTableAdapter" GeneratorDataComponentClassName="SolicitacaoProcedimentoTableAdapter" Name="SolicitacaoProcedimento" UserDataComponentName="SolicitacaoProcedimentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="SolicitacaoProcedimento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `SolicitacaoProcedimento` WHERE ((`numeroGuia` = ?) AND ((? = 1 AND `tipoSolic_cod` IS NULL) OR (`tipoSolic_cod` = ?)) AND ((? = 1 AND `sequencialTransacao` IS NULL) OR (`sequencialTransacao` = ?)) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND (`codPrestador` = ?) AND (`regANS` = ?) AND ((? = 1 AND `cancelada` IS NULL) OR (`cancelada` = ?)) AND ((? = 1 AND `glosa` IS NULL) OR (`glosa` = ?)) AND ((? = 1 AND `numeroGuiaOperadora` IS NULL) OR (`numeroGuiaOperadora` = ?)) AND ((? = 1 AND `dataEmissao` IS NULL) OR (`dataEmissao` = ?)) AND ((? = 1 AND `codStatusRecebimento` IS NULL) OR (`codStatusRecebimento` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoSolic_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoSolic_cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cancelada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_glosa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuiaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataEmissao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codStatusRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `SolicitacaoProcedimento` (`numeroGuia`, `tipoSolic_cod`, `sequencialTransacao`, `local`, `codPrestador`, `regANS`, `cancelada`, `glosa`, `numeroGuiaOperadora`, `dataEmissao`, `codStatusRecebimento`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoSolic_cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT numeroGuia, tipoSolic_cod, sequencialTransacao, [local], codPrestador, regANS, cancelada, glosa, numeroGuiaOperadora, dataEmissao, codStatusRecebimento FROM SolicitacaoProcedimento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `SolicitacaoProcedimento` SET `numeroGuia` = ?, `tipoSolic_cod` = ?, `sequencialTransacao` = ?, `local` = ?, `codPrestador` = ?, `regANS` = ?, `cancelada` = ?, `glosa` = ?, `numeroGuiaOperadora` = ?, `dataEmissao` = ?, `codStatusRecebimento` = ? WHERE ((`numeroGuia` = ?) AND ((? = 1 AND `tipoSolic_cod` IS NULL) OR (`tipoSolic_cod` = ?)) AND ((? = 1 AND `sequencialTransacao` IS NULL) OR (`sequencialTransacao` = ?)) AND ((? = 1 AND `local` IS NULL) OR (`local` = ?)) AND (`codPrestador` = ?) AND (`regANS` = ?) AND ((? = 1 AND `cancelada` IS NULL) OR (`cancelada` = ?)) AND ((? = 1 AND `glosa` IS NULL) OR (`glosa` = ?)) AND ((? = 1 AND `numeroGuiaOperadora` IS NULL) OR (`numeroGuiaOperadora` = ?)) AND ((? = 1 AND `dataEmissao` IS NULL) OR (`dataEmissao` = ?)) AND ((? = 1 AND `codStatusRecebimento` IS NULL) OR (`codStatusRecebimento` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoSolic_cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoSolic_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoSolic_cod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoSolic_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sequencialTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sequencialTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_local" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_local" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="local" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cancelada" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_cancelada" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="cancelada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_glosa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_glosa" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="glosa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_numeroGuiaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuiaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuiaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_dataEmissao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_dataEmissao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="dataEmissao" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codStatusRecebimento" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_codStatusRecebimento" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="codStatusRecebimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="numeroGuia" DataSetColumn="numeroGuia" />
              <Mapping SourceColumn="tipoSolic_cod" DataSetColumn="tipoSolic_cod" />
              <Mapping SourceColumn="sequencialTransacao" DataSetColumn="sequencialTransacao" />
              <Mapping SourceColumn="local" DataSetColumn="local" />
              <Mapping SourceColumn="codPrestador" DataSetColumn="codPrestador" />
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
              <Mapping SourceColumn="cancelada" DataSetColumn="cancelada" />
              <Mapping SourceColumn="glosa" DataSetColumn="glosa" />
              <Mapping SourceColumn="numeroGuiaOperadora" DataSetColumn="numeroGuiaOperadora" />
              <Mapping SourceColumn="dataEmissao" DataSetColumn="dataEmissao" />
              <Mapping SourceColumn="codStatusRecebimento" DataSetColumn="codStatusRecebimento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusProcFaturamentoTableAdapter" GeneratorDataComponentClassName="StatusProcFaturamentoTableAdapter" Name="StatusProcFaturamento" UserDataComponentName="StatusProcFaturamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="StatusProcFaturamento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `StatusProcFaturamento` WHERE ((`numeroGuia` = ?) AND (`IDLote` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `StatusProcFaturamento` (`numeroGuia`, `IDLote`, `statusProcedimentos`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="statusProcedimentos" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="statusProcedimentos" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT numeroGuia, IDLote, statusProcedimentos FROM StatusProcFaturamento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `StatusProcFaturamento` SET `numeroGuia` = ?, `IDLote` = ?, `statusProcedimentos` = ? WHERE ((`numeroGuia` = ?) AND (`IDLote` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="statusProcedimentos" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="statusProcedimentos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_numeroGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="numeroGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDLote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDLote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="numeroGuia" DataSetColumn="numeroGuia" />
              <Mapping SourceColumn="IDLote" DataSetColumn="IDLote" />
              <Mapping SourceColumn="statusProcedimentos" DataSetColumn="statusProcedimentos" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="statusRecebimentoTableAdapter" GeneratorDataComponentClassName="statusRecebimentoTableAdapter" Name="statusRecebimento" UserDataComponentName="statusRecebimentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="statusRecebimento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `statusRecebimento` WHERE ((`ID` = ?) AND ((? = 1 AND `Descricao` IS NULL) OR (`Descricao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Descricao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `statusRecebimento` (`ID`, `Descricao`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Descricao FROM statusRecebimento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `statusRecebimento` SET `ID` = ?, `Descricao` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Descricao` IS NULL) OR (`Descricao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Descricao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipoGuiaTableAdapter" GeneratorDataComponentClassName="tipoGuiaTableAdapter" Name="tipoGuia" UserDataComponentName="tipoGuiaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="tipoGuia" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tipoGuia` WHERE ((`tipoGuiaCod` = ?) AND ((? = 1 AND `tipoGuia` IS NULL) OR (`tipoGuia` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoGuiaCod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuiaCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tipoGuia` (`tipoGuiaCod`, `tipoGuia`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoGuiaCod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuiaCod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT tipoGuiaCod, tipoGuia FROM tipoGuia</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tipoGuia` SET `tipoGuiaCod` = ?, `tipoGuia` = ? WHERE ((`tipoGuiaCod` = ?) AND ((? = 1 AND `tipoGuia` IS NULL) OR (`tipoGuia` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="tipoGuiaCod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuiaCod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_tipoGuiaCod" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="tipoGuiaCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoGuia" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoGuia" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoGuia" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="tipoGuiaCod" DataSetColumn="tipoGuiaCod" />
              <Mapping SourceColumn="tipoGuia" DataSetColumn="tipoGuia" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipoTransacaoTableAdapter" GeneratorDataComponentClassName="tipoTransacaoTableAdapter" Name="tipoTransacao" UserDataComponentName="tipoTransacaoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="tipoTransacao" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tipoTransacao` WHERE ((`tipoCod` = ?) AND ((? = 1 AND `tipoTransacao` IS NULL) OR (`tipoTransacao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoTransacao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tipoTransacao` (`tipoTransacao`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoTransacao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT tipoCod, tipoTransacao FROM tipoTransacao</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tipoTransacao` SET `tipoTransacao` = ? WHERE ((`tipoCod` = ?) AND ((? = 1 AND `tipoTransacao` IS NULL) OR (`tipoTransacao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="tipoTransacao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoCod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoCod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_tipoTransacao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_tipoTransacao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="tipoTransacao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="tipoCod" DataSetColumn="tipoCod" />
              <Mapping SourceColumn="tipoTransacao" DataSetColumn="tipoTransacao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tipoURLTableAdapter" GeneratorDataComponentClassName="tipoURLTableAdapter" Name="tipoURL" UserDataComponentName="tipoURLTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="tipoURL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tipoURL` WHERE ((`tipoURL_cod` = ?) AND ((? = 1 AND `Descricao` IS NULL) OR (`Descricao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Descricao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tipoURL` (`Descricao`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT tipoURL_cod, Descricao FROM tipoURL</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tipoURL` SET `Descricao` = ? WHERE ((`tipoURL_cod` = ?) AND ((? = 1 AND `Descricao` IS NULL) OR (`Descricao` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_tipoURL_cod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="tipoURL_cod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Descricao" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Descricao" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Descricao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="tipoURL_cod" DataSetColumn="tipoURL_cod" />
              <Mapping SourceColumn="Descricao" DataSetColumn="Descricao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrabalhaTableAdapter" GeneratorDataComponentClassName="TrabalhaTableAdapter" Name="Trabalha" UserDataComponentName="TrabalhaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="modconConnectionString (Settings)" DbObjectName="Trabalha" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Trabalha` WHERE ((`ID` = ?) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)) AND ((? = 1 AND `codnaOperadora` IS NULL) OR (`codnaOperadora` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codnaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codnaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Trabalha` (`codPrestador`, `regANS`, `codnaOperadora`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codnaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, codPrestador, regANS, codnaOperadora FROM Trabalha</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Trabalha` SET `codPrestador` = ?, `regANS` = ?, `codnaOperadora` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `codPrestador` IS NULL) OR (`codPrestador` = ?)) AND ((? = 1 AND `regANS` IS NULL) OR (`regANS` = ?)) AND ((? = 1 AND `codnaOperadora` IS NULL) OR (`codnaOperadora` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="codnaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_codPrestador" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codPrestador" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_regANS" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_regANS" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="regANS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_codnaOperadora" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_codnaOperadora" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="codnaOperadora" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="codPrestador" DataSetColumn="codPrestador" />
              <Mapping SourceColumn="regANS" DataSetColumn="regANS" />
              <Mapping SourceColumn="codnaOperadora" DataSetColumn="codnaOperadora" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="modconDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="modconDataSet" msprop:Generator_UserDSName="modconDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Clin_Hosp" msprop:Generator_UserTableName="Clin_Hosp" msprop:Generator_RowDeletedName="Clin_HospRowDeleted" msprop:Generator_TableClassName="Clin_HospDataTable" msprop:Generator_RowChangedName="Clin_HospRowChanged" msprop:Generator_RowClassName="Clin_HospRow" msprop:Generator_RowChangingName="Clin_HospRowChanging" msprop:Generator_RowEvArgName="Clin_HospRowChangeEvent" msprop:Generator_RowEvHandlerName="Clin_HospRowChangeEventHandler" msprop:Generator_TablePropName="Clin_Hosp" msprop:Generator_TableVarName="tableClin_Hosp" msprop:Generator_RowDeletingName="Clin_HospRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="CNES" msprop:Generator_UserColumnName="CNES" msprop:Generator_ColumnPropNameInRow="CNES" msprop:Generator_ColumnVarNameInTable="columnCNES" msprop:Generator_ColumnPropNameInTable="CNESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CNPJ" msprop:Generator_UserColumnName="CNPJ" msprop:Generator_ColumnPropNameInRow="CNPJ" msprop:Generator_ColumnVarNameInTable="columnCNPJ" msprop:Generator_ColumnPropNameInTable="CNPJColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DemonstrativoRetorno" msprop:Generator_UserTableName="DemonstrativoRetorno" msprop:Generator_RowDeletedName="DemonstrativoRetornoRowDeleted" msprop:Generator_TableClassName="DemonstrativoRetornoDataTable" msprop:Generator_RowChangedName="DemonstrativoRetornoRowChanged" msprop:Generator_RowClassName="DemonstrativoRetornoRow" msprop:Generator_RowChangingName="DemonstrativoRetornoRowChanging" msprop:Generator_RowEvArgName="DemonstrativoRetornoRowChangeEvent" msprop:Generator_RowEvHandlerName="DemonstrativoRetornoRowChangeEventHandler" msprop:Generator_TablePropName="DemonstrativoRetorno" msprop:Generator_TableVarName="tableDemonstrativoRetorno" msprop:Generator_RowDeletingName="DemonstrativoRetornoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="demonstrativoCod" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="demonstrativoCod" msprop:Generator_ColumnPropNameInRow="demonstrativoCod" msprop:Generator_ColumnVarNameInTable="columndemonstrativoCod" msprop:Generator_ColumnPropNameInTable="demonstrativoCodColumn" type="xs:int" />
              <xs:element name="tipoSolic_Cod" msprop:Generator_UserColumnName="tipoSolic_Cod" msprop:Generator_ColumnPropNameInRow="tipoSolic_Cod" msprop:Generator_ColumnVarNameInTable="columntipoSolic_Cod" msprop:Generator_ColumnPropNameInTable="tipoSolic_CodColumn" type="xs:short" minOccurs="0" />
              <xs:element name="SequencialTransacao" msprop:Generator_UserColumnName="SequencialTransacao" msprop:Generator_ColumnPropNameInRow="SequencialTransacao" msprop:Generator_ColumnVarNameInTable="columnSequencialTransacao" msprop:Generator_ColumnPropNameInTable="SequencialTransacaoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="codPrestador" msprop:Generator_UserColumnName="codPrestador" msprop:Generator_ColumnPropNameInRow="codPrestador" msprop:Generator_ColumnVarNameInTable="columncodPrestador" msprop:Generator_ColumnPropNameInTable="codPrestadorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loteID" msprop:Generator_UserColumnName="loteID" msprop:Generator_ColumnPropNameInRow="loteID" msprop:Generator_ColumnVarNameInTable="columnloteID" msprop:Generator_ColumnPropNameInTable="loteIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="demonstrativo" msprop:Generator_UserColumnName="demonstrativo" msprop:Generator_ColumnPropNameInRow="demonstrativo" msprop:Generator_ColumnVarNameInTable="columndemonstrativo" msprop:Generator_ColumnPropNameInTable="demonstrativoColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ExtensaoSolicProc" msprop:Generator_UserTableName="ExtensaoSolicProc" msprop:Generator_RowDeletedName="ExtensaoSolicProcRowDeleted" msprop:Generator_TableClassName="ExtensaoSolicProcDataTable" msprop:Generator_RowChangedName="ExtensaoSolicProcRowChanged" msprop:Generator_RowClassName="ExtensaoSolicProcRow" msprop:Generator_RowChangingName="ExtensaoSolicProcRowChanging" msprop:Generator_RowEvArgName="ExtensaoSolicProcRowChangeEvent" msprop:Generator_RowEvHandlerName="ExtensaoSolicProcRowChangeEventHandler" msprop:Generator_TablePropName="ExtensaoSolicProc" msprop:Generator_TableVarName="tableExtensaoSolicProc" msprop:Generator_RowDeletingName="ExtensaoSolicProcRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="numeroGuia" msprop:Generator_UserColumnName="numeroGuia" msprop:Generator_ColumnPropNameInRow="numeroGuia" msprop:Generator_ColumnVarNameInTable="columnnumeroGuia" msprop:Generator_ColumnPropNameInTable="numeroGuiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="local" msprop:Generator_UserColumnName="local" msprop:Generator_ColumnPropNameInRow="local" msprop:Generator_ColumnVarNameInTable="columnlocal" msprop:Generator_ColumnPropNameInTable="localColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codPrestador" msprop:Generator_UserColumnName="codPrestador" msprop:Generator_ColumnPropNameInRow="codPrestador" msprop:Generator_ColumnVarNameInTable="columncodPrestador" msprop:Generator_ColumnPropNameInTable="codPrestadorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="guia" msprop:Generator_UserTableName="guia" msprop:Generator_RowDeletedName="guiaRowDeleted" msprop:Generator_TableClassName="guiaDataTable" msprop:Generator_RowChangedName="guiaRowChanged" msprop:Generator_RowClassName="guiaRow" msprop:Generator_RowChangingName="guiaRowChanging" msprop:Generator_RowEvArgName="guiaRowChangeEvent" msprop:Generator_RowEvHandlerName="guiaRowChangeEventHandler" msprop:Generator_TablePropName="guia" msprop:Generator_TableVarName="tableguia" msprop:Generator_RowDeletingName="guiaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="numeroGuia" msprop:Generator_UserColumnName="numeroGuia" msprop:Generator_ColumnPropNameInRow="numeroGuia" msprop:Generator_ColumnVarNameInTable="columnnumeroGuia" msprop:Generator_ColumnPropNameInTable="numeroGuiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="local" msprop:Generator_UserColumnName="local" msprop:Generator_ColumnPropNameInRow="local" msprop:Generator_ColumnVarNameInTable="columnlocal" msprop:Generator_ColumnPropNameInTable="localColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cancelada" msprop:Generator_UserColumnName="cancelada" msprop:Generator_ColumnPropNameInRow="cancelada" msprop:Generator_ColumnVarNameInTable="columncancelada" msprop:Generator_ColumnPropNameInTable="canceladaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="IDLote" msprop:Generator_UserColumnName="IDLote" msprop:Generator_ColumnPropNameInRow="IDLote" msprop:Generator_ColumnVarNameInTable="columnIDLote" msprop:Generator_ColumnPropNameInTable="IDLoteColumn" type="xs:int" />
              <xs:element name="dataEmissao" msprop:Generator_UserColumnName="dataEmissao" msprop:Generator_ColumnPropNameInRow="dataEmissao" msprop:Generator_ColumnVarNameInTable="columndataEmissao" msprop:Generator_ColumnPropNameInTable="dataEmissaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="glosa" msprop:Generator_UserColumnName="glosa" msprop:Generator_ColumnPropNameInRow="glosa" msprop:Generator_ColumnVarNameInTable="columnglosa" msprop:Generator_ColumnPropNameInTable="glosaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="reapresentada" msprop:Generator_UserColumnName="reapresentada" msprop:Generator_ColumnPropNameInRow="reapresentada" msprop:Generator_ColumnVarNameInTable="columnreapresentada" msprop:Generator_ColumnPropNameInTable="reapresentadaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="numeroGuiaOperadora" msprop:Generator_UserColumnName="numeroGuiaOperadora" msprop:Generator_ColumnPropNameInRow="numeroGuiaOperadora" msprop:Generator_ColumnVarNameInTable="columnnumeroGuiaOperadora" msprop:Generator_ColumnPropNameInTable="numeroGuiaOperadoraColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="guiaOutrasDespesas" msprop:Generator_UserTableName="guiaOutrasDespesas" msprop:Generator_RowDeletedName="guiaOutrasDespesasRowDeleted" msprop:Generator_TableClassName="guiaOutrasDespesasDataTable" msprop:Generator_RowChangedName="guiaOutrasDespesasRowChanged" msprop:Generator_RowClassName="guiaOutrasDespesasRow" msprop:Generator_RowChangingName="guiaOutrasDespesasRowChanging" msprop:Generator_RowEvArgName="guiaOutrasDespesasRowChangeEvent" msprop:Generator_RowEvHandlerName="guiaOutrasDespesasRowChangeEventHandler" msprop:Generator_TablePropName="guiaOutrasDespesas" msprop:Generator_TableVarName="tableguiaOutrasDespesas" msprop:Generator_RowDeletingName="guiaOutrasDespesasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="local" msprop:Generator_UserColumnName="local" msprop:Generator_ColumnPropNameInRow="local" msprop:Generator_ColumnVarNameInTable="columnlocal" msprop:Generator_ColumnPropNameInTable="localColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numeroGuia" msprop:Generator_UserColumnName="numeroGuia" msprop:Generator_ColumnPropNameInRow="numeroGuia" msprop:Generator_ColumnVarNameInTable="columnnumeroGuia" msprop:Generator_ColumnPropNameInTable="numeroGuiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLote" msprop:Generator_UserColumnName="IDLote" msprop:Generator_ColumnPropNameInRow="IDLote" msprop:Generator_ColumnVarNameInTable="columnIDLote" msprop:Generator_ColumnPropNameInTable="IDLoteColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IntervaloLote" msprop:Generator_UserTableName="IntervaloLote" msprop:Generator_RowDeletedName="IntervaloLoteRowDeleted" msprop:Generator_TableClassName="IntervaloLoteDataTable" msprop:Generator_RowChangedName="IntervaloLoteRowChanged" msprop:Generator_RowClassName="IntervaloLoteRow" msprop:Generator_RowChangingName="IntervaloLoteRowChanging" msprop:Generator_RowEvArgName="IntervaloLoteRowChangeEvent" msprop:Generator_RowEvHandlerName="IntervaloLoteRowChangeEventHandler" msprop:Generator_TablePropName="IntervaloLote" msprop:Generator_TableVarName="tableIntervaloLote" msprop:Generator_RowDeletingName="IntervaloLoteRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="IDTrabalha" msprop:Generator_UserColumnName="IDTrabalha" msprop:Generator_ColumnPropNameInRow="IDTrabalha" msprop:Generator_ColumnVarNameInTable="columnIDTrabalha" msprop:Generator_ColumnPropNameInTable="IDTrabalhaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="De" msprop:Generator_UserColumnName="De" msprop:Generator_ColumnPropNameInRow="De" msprop:Generator_ColumnVarNameInTable="columnDe" msprop:Generator_ColumnPropNameInTable="DeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Ate" msprop:Generator_UserColumnName="Ate" msprop:Generator_ColumnPropNameInRow="Ate" msprop:Generator_ColumnVarNameInTable="columnAte" msprop:Generator_ColumnPropNameInTable="AteColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Atual" msprop:Generator_UserColumnName="Atual" msprop:Generator_ColumnPropNameInRow="Atual" msprop:Generator_ColumnVarNameInTable="columnAtual" msprop:Generator_ColumnPropNameInTable="AtualColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Login" msprop:Generator_UserTableName="Login" msprop:Generator_RowDeletedName="LoginRowDeleted" msprop:Generator_TableClassName="LoginDataTable" msprop:Generator_RowChangedName="LoginRowChanged" msprop:Generator_RowClassName="LoginRow" msprop:Generator_RowChangingName="LoginRowChanging" msprop:Generator_RowEvArgName="LoginRowChangeEvent" msprop:Generator_RowEvHandlerName="LoginRowChangeEventHandler" msprop:Generator_TablePropName="Login" msprop:Generator_TableVarName="tableLogin" msprop:Generator_RowDeletingName="LoginRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Usuario" msprop:Generator_UserColumnName="Usuario" msprop:Generator_ColumnPropNameInRow="Usuario" msprop:Generator_ColumnVarNameInTable="columnUsuario" msprop:Generator_ColumnPropNameInTable="UsuarioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Senha" msprop:Generator_UserColumnName="Senha" msprop:Generator_ColumnPropNameInRow="Senha" msprop:Generator_ColumnVarNameInTable="columnSenha" msprop:Generator_ColumnPropNameInTable="SenhaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LoteGuias" msprop:Generator_UserTableName="LoteGuias" msprop:Generator_RowDeletedName="LoteGuiasRowDeleted" msprop:Generator_TableClassName="LoteGuiasDataTable" msprop:Generator_RowChangedName="LoteGuiasRowChanged" msprop:Generator_RowClassName="LoteGuiasRow" msprop:Generator_RowChangingName="LoteGuiasRowChanging" msprop:Generator_RowEvArgName="LoteGuiasRowChangeEvent" msprop:Generator_RowEvHandlerName="LoteGuiasRowChangeEventHandler" msprop:Generator_TablePropName="LoteGuias" msprop:Generator_TableVarName="tableLoteGuias" msprop:Generator_RowDeletingName="LoteGuiasRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="numeroLote" msprop:Generator_UserColumnName="numeroLote" msprop:Generator_ColumnPropNameInRow="numeroLote" msprop:Generator_ColumnVarNameInTable="columnnumeroLote" msprop:Generator_ColumnPropNameInTable="numeroLoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sequencialTransacao" msprop:Generator_UserColumnName="sequencialTransacao" msprop:Generator_ColumnPropNameInRow="sequencialTransacao" msprop:Generator_ColumnVarNameInTable="columnsequencialTransacao" msprop:Generator_ColumnPropNameInTable="sequencialTransacaoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="protocoloRecebimento" msprop:Generator_UserColumnName="protocoloRecebimento" msprop:Generator_ColumnPropNameInRow="protocoloRecebimento" msprop:Generator_ColumnVarNameInTable="columnprotocoloRecebimento" msprop:Generator_ColumnPropNameInTable="protocoloRecebimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="240" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codStatusRecebimento" msprop:Generator_UserColumnName="codStatusRecebimento" msprop:Generator_ColumnPropNameInRow="codStatusRecebimento" msprop:Generator_ColumnVarNameInTable="columncodStatusRecebimento" msprop:Generator_ColumnPropNameInTable="codStatusRecebimentoColumn" type="xs:short" minOccurs="0" />
              <xs:element name="tipoGuia" msprop:Generator_UserColumnName="tipoGuia" msprop:Generator_ColumnPropNameInRow="tipoGuia" msprop:Generator_ColumnVarNameInTable="columntipoGuia" msprop:Generator_ColumnPropNameInTable="tipoGuiaColumn" type="xs:short" minOccurs="0" />
              <xs:element name="codPrestador" msprop:Generator_UserColumnName="codPrestador" msprop:Generator_ColumnPropNameInRow="codPrestador" msprop:Generator_ColumnVarNameInTable="columncodPrestador" msprop:Generator_ColumnPropNameInTable="codPrestadorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Mensagem" msprop:Generator_UserTableName="Mensagem" msprop:Generator_RowDeletedName="MensagemRowDeleted" msprop:Generator_TableClassName="MensagemDataTable" msprop:Generator_RowChangedName="MensagemRowChanged" msprop:Generator_RowClassName="MensagemRow" msprop:Generator_RowChangingName="MensagemRowChanging" msprop:Generator_RowEvArgName="MensagemRowChangeEvent" msprop:Generator_RowEvHandlerName="MensagemRowChangeEventHandler" msprop:Generator_TablePropName="Mensagem" msprop:Generator_TableVarName="tableMensagem" msprop:Generator_RowDeletingName="MensagemRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sequencialTransacao" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="sequencialTransacao" msprop:Generator_ColumnPropNameInRow="sequencialTransacao" msprop:Generator_ColumnVarNameInTable="columnsequencialTransacao" msprop:Generator_ColumnPropNameInTable="sequencialTransacaoColumn" type="xs:int" />
              <xs:element name="dataTransacao" msprop:Generator_UserColumnName="dataTransacao" msprop:Generator_ColumnPropNameInRow="dataTransacao" msprop:Generator_ColumnVarNameInTable="columndataTransacao" msprop:Generator_ColumnPropNameInTable="dataTransacaoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tipoCod" msprop:Generator_UserColumnName="tipoCod" msprop:Generator_ColumnPropNameInRow="tipoCod" msprop:Generator_ColumnVarNameInTable="columntipoCod" msprop:Generator_ColumnPropNameInTable="tipoCodColumn" type="xs:int" minOccurs="0" />
              <xs:element name="origem" msprop:Generator_UserColumnName="origem" msprop:Generator_ColumnPropNameInRow="origem" msprop:Generator_ColumnVarNameInTable="columnorigem" msprop:Generator_ColumnPropNameInTable="origemColumn" type="xs:int" minOccurs="0" />
              <xs:element name="destino" msprop:Generator_UserColumnName="destino" msprop:Generator_ColumnPropNameInRow="destino" msprop:Generator_ColumnVarNameInTable="columndestino" msprop:Generator_ColumnPropNameInTable="destinoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Operadora" msprop:Generator_UserTableName="Operadora" msprop:Generator_RowDeletedName="OperadoraRowDeleted" msprop:Generator_TableClassName="OperadoraDataTable" msprop:Generator_RowChangedName="OperadoraRowChanged" msprop:Generator_RowClassName="OperadoraRow" msprop:Generator_RowChangingName="OperadoraRowChanging" msprop:Generator_RowEvArgName="OperadoraRowChangeEvent" msprop:Generator_RowEvHandlerName="OperadoraRowChangeEventHandler" msprop:Generator_TablePropName="Operadora" msprop:Generator_TableVarName="tableOperadora" msprop:Generator_RowDeletingName="OperadoraRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nome" msprop:Generator_UserColumnName="nome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInTable="nomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="logo" msprop:Generator_UserColumnName="logo" msprop:Generator_ColumnPropNameInRow="logo" msprop:Generator_ColumnVarNameInTable="columnlogo" msprop:Generator_ColumnPropNameInTable="logoColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OperadoraURLs" msprop:Generator_UserTableName="OperadoraURLs" msprop:Generator_RowDeletedName="OperadoraURLsRowDeleted" msprop:Generator_TableClassName="OperadoraURLsDataTable" msprop:Generator_RowChangedName="OperadoraURLsRowChanged" msprop:Generator_RowClassName="OperadoraURLsRow" msprop:Generator_RowChangingName="OperadoraURLsRowChanging" msprop:Generator_RowEvArgName="OperadoraURLsRowChangeEvent" msprop:Generator_RowEvHandlerName="OperadoraURLsRowChangeEventHandler" msprop:Generator_TablePropName="OperadoraURLs" msprop:Generator_TableVarName="tableOperadoraURLs" msprop:Generator_RowDeletingName="OperadoraURLsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipoURL_cod" msprop:Generator_UserColumnName="tipoURL_cod" msprop:Generator_ColumnPropNameInRow="tipoURL_cod" msprop:Generator_ColumnVarNameInTable="columntipoURL_cod" msprop:Generator_ColumnPropNameInTable="tipoURL_codColumn" type="xs:int" />
              <xs:element name="url" msprop:Generator_UserColumnName="url" msprop:Generator_ColumnPropNameInRow="url" msprop:Generator_ColumnVarNameInTable="columnurl" msprop:Generator_ColumnPropNameInTable="urlColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Prestador" msprop:Generator_UserTableName="Prestador" msprop:Generator_RowDeletedName="PrestadorRowDeleted" msprop:Generator_TableClassName="PrestadorDataTable" msprop:Generator_RowChangedName="PrestadorRowChanged" msprop:Generator_RowClassName="PrestadorRow" msprop:Generator_RowChangingName="PrestadorRowChanging" msprop:Generator_RowEvArgName="PrestadorRowChangeEvent" msprop:Generator_RowEvHandlerName="PrestadorRowChangeEventHandler" msprop:Generator_TablePropName="Prestador" msprop:Generator_TableVarName="tablePrestador" msprop:Generator_RowDeletingName="PrestadorRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="nome" msprop:Generator_UserColumnName="nome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInTable="nomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipoLogradouro" msprop:Generator_UserColumnName="tipoLogradouro" msprop:Generator_ColumnPropNameInRow="tipoLogradouro" msprop:Generator_ColumnVarNameInTable="columntipoLogradouro" msprop:Generator_ColumnPropNameInTable="tipoLogradouroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="logradouro" msprop:Generator_UserColumnName="logradouro" msprop:Generator_ColumnPropNameInRow="logradouro" msprop:Generator_ColumnVarNameInTable="columnlogradouro" msprop:Generator_ColumnPropNameInTable="logradouroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numero" msprop:Generator_UserColumnName="numero" msprop:Generator_ColumnPropNameInRow="numero" msprop:Generator_ColumnVarNameInTable="columnnumero" msprop:Generator_ColumnPropNameInTable="numeroColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="complemento" msprop:Generator_UserColumnName="complemento" msprop:Generator_ColumnPropNameInRow="complemento" msprop:Generator_ColumnVarNameInTable="columncomplemento" msprop:Generator_ColumnPropNameInTable="complementoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codIBGEMun" msprop:Generator_UserColumnName="codIBGEMun" msprop:Generator_ColumnPropNameInRow="codIBGEMun" msprop:Generator_ColumnVarNameInTable="columncodIBGEMun" msprop:Generator_ColumnPropNameInTable="codIBGEMunColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="municipio" msprop:Generator_UserColumnName="municipio" msprop:Generator_ColumnPropNameInRow="municipio" msprop:Generator_ColumnVarNameInTable="columnmunicipio" msprop:Generator_ColumnPropNameInTable="municipioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codUF" msprop:Generator_UserColumnName="codUF" msprop:Generator_ColumnPropNameInRow="codUF" msprop:Generator_ColumnVarNameInTable="columncodUF" msprop:Generator_ColumnPropNameInTable="codUFColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CEP" msprop:Generator_UserColumnName="CEP" msprop:Generator_ColumnPropNameInRow="CEP" msprop:Generator_ColumnVarNameInTable="columnCEP" msprop:Generator_ColumnPropNameInTable="CEPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Profissional" msprop:Generator_UserTableName="Profissional" msprop:Generator_RowDeletedName="ProfissionalRowDeleted" msprop:Generator_TableClassName="ProfissionalDataTable" msprop:Generator_RowChangedName="ProfissionalRowChanged" msprop:Generator_RowClassName="ProfissionalRow" msprop:Generator_RowChangingName="ProfissionalRowChanging" msprop:Generator_RowEvArgName="ProfissionalRowChangeEvent" msprop:Generator_RowEvHandlerName="ProfissionalRowChangeEventHandler" msprop:Generator_TablePropName="Profissional" msprop:Generator_TableVarName="tableProfissional" msprop:Generator_RowDeletingName="ProfissionalRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="siglaConselho" msprop:Generator_UserColumnName="siglaConselho" msprop:Generator_ColumnPropNameInRow="siglaConselho" msprop:Generator_ColumnVarNameInTable="columnsiglaConselho" msprop:Generator_ColumnPropNameInTable="siglaConselhoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="numeroConselho" msprop:Generator_UserColumnName="numeroConselho" msprop:Generator_ColumnPropNameInRow="numeroConselho" msprop:Generator_ColumnVarNameInTable="columnnumeroConselho" msprop:Generator_ColumnPropNameInTable="numeroConselhoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ufConselho" msprop:Generator_UserColumnName="ufConselho" msprop:Generator_ColumnPropNameInRow="ufConselho" msprop:Generator_ColumnVarNameInTable="columnufConselho" msprop:Generator_ColumnPropNameInTable="ufConselhoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CPF" msprop:Generator_UserColumnName="CPF" msprop:Generator_ColumnPropNameInRow="CPF" msprop:Generator_ColumnVarNameInTable="columnCPF" msprop:Generator_ColumnPropNameInTable="CPFColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SolicitacaoProcedimento" msprop:Generator_UserTableName="SolicitacaoProcedimento" msprop:Generator_RowDeletedName="SolicitacaoProcedimentoRowDeleted" msprop:Generator_TableClassName="SolicitacaoProcedimentoDataTable" msprop:Generator_RowChangedName="SolicitacaoProcedimentoRowChanged" msprop:Generator_RowClassName="SolicitacaoProcedimentoRow" msprop:Generator_RowChangingName="SolicitacaoProcedimentoRowChanging" msprop:Generator_RowEvArgName="SolicitacaoProcedimentoRowChangeEvent" msprop:Generator_RowEvHandlerName="SolicitacaoProcedimentoRowChangeEventHandler" msprop:Generator_TablePropName="SolicitacaoProcedimento" msprop:Generator_TableVarName="tableSolicitacaoProcedimento" msprop:Generator_RowDeletingName="SolicitacaoProcedimentoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="numeroGuia" msprop:Generator_UserColumnName="numeroGuia" msprop:Generator_ColumnPropNameInRow="numeroGuia" msprop:Generator_ColumnVarNameInTable="columnnumeroGuia" msprop:Generator_ColumnPropNameInTable="numeroGuiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipoSolic_cod" msprop:Generator_UserColumnName="tipoSolic_cod" msprop:Generator_ColumnPropNameInRow="tipoSolic_cod" msprop:Generator_ColumnVarNameInTable="columntipoSolic_cod" msprop:Generator_ColumnPropNameInTable="tipoSolic_codColumn" type="xs:short" minOccurs="0" />
              <xs:element name="sequencialTransacao" msprop:Generator_UserColumnName="sequencialTransacao" msprop:Generator_ColumnPropNameInRow="sequencialTransacao" msprop:Generator_ColumnVarNameInTable="columnsequencialTransacao" msprop:Generator_ColumnPropNameInTable="sequencialTransacaoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="local" msprop:Generator_UserColumnName="local" msprop:Generator_ColumnPropNameInRow="local" msprop:Generator_ColumnVarNameInTable="columnlocal" msprop:Generator_ColumnPropNameInTable="localColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codPrestador" msprop:Generator_UserColumnName="codPrestador" msprop:Generator_ColumnPropNameInRow="codPrestador" msprop:Generator_ColumnVarNameInTable="columncodPrestador" msprop:Generator_ColumnPropNameInTable="codPrestadorColumn" type="xs:int" />
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cancelada" msprop:Generator_UserColumnName="cancelada" msprop:Generator_ColumnPropNameInRow="cancelada" msprop:Generator_ColumnVarNameInTable="columncancelada" msprop:Generator_ColumnPropNameInTable="canceladaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="glosa" msprop:Generator_UserColumnName="glosa" msprop:Generator_ColumnPropNameInRow="glosa" msprop:Generator_ColumnVarNameInTable="columnglosa" msprop:Generator_ColumnPropNameInTable="glosaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="numeroGuiaOperadora" msprop:Generator_UserColumnName="numeroGuiaOperadora" msprop:Generator_ColumnPropNameInRow="numeroGuiaOperadora" msprop:Generator_ColumnVarNameInTable="columnnumeroGuiaOperadora" msprop:Generator_ColumnPropNameInTable="numeroGuiaOperadoraColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dataEmissao" msprop:Generator_UserColumnName="dataEmissao" msprop:Generator_ColumnPropNameInRow="dataEmissao" msprop:Generator_ColumnVarNameInTable="columndataEmissao" msprop:Generator_ColumnPropNameInTable="dataEmissaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codStatusRecebimento" msprop:Generator_UserColumnName="codStatusRecebimento" msprop:Generator_ColumnPropNameInRow="codStatusRecebimento" msprop:Generator_ColumnVarNameInTable="columncodStatusRecebimento" msprop:Generator_ColumnPropNameInTable="codStatusRecebimentoColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StatusProcFaturamento" msprop:Generator_UserTableName="StatusProcFaturamento" msprop:Generator_RowDeletedName="StatusProcFaturamentoRowDeleted" msprop:Generator_TableClassName="StatusProcFaturamentoDataTable" msprop:Generator_RowChangedName="StatusProcFaturamentoRowChanged" msprop:Generator_RowClassName="StatusProcFaturamentoRow" msprop:Generator_RowChangingName="StatusProcFaturamentoRowChanging" msprop:Generator_RowEvArgName="StatusProcFaturamentoRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusProcFaturamentoRowChangeEventHandler" msprop:Generator_TablePropName="StatusProcFaturamento" msprop:Generator_TableVarName="tableStatusProcFaturamento" msprop:Generator_RowDeletingName="StatusProcFaturamentoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="numeroGuia" msprop:Generator_UserColumnName="numeroGuia" msprop:Generator_ColumnPropNameInRow="numeroGuia" msprop:Generator_ColumnVarNameInTable="columnnumeroGuia" msprop:Generator_ColumnPropNameInTable="numeroGuiaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLote" msprop:Generator_UserColumnName="IDLote" msprop:Generator_ColumnPropNameInRow="IDLote" msprop:Generator_ColumnVarNameInTable="columnIDLote" msprop:Generator_ColumnPropNameInTable="IDLoteColumn" type="xs:int" />
              <xs:element name="statusProcedimentos" msprop:Generator_UserColumnName="statusProcedimentos" msprop:Generator_ColumnPropNameInRow="statusProcedimentos" msprop:Generator_ColumnVarNameInTable="columnstatusProcedimentos" msprop:Generator_ColumnPropNameInTable="statusProcedimentosColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="statusRecebimento" msprop:Generator_UserTableName="statusRecebimento" msprop:Generator_RowDeletedName="statusRecebimentoRowDeleted" msprop:Generator_TableClassName="statusRecebimentoDataTable" msprop:Generator_RowChangedName="statusRecebimentoRowChanged" msprop:Generator_RowClassName="statusRecebimentoRow" msprop:Generator_RowChangingName="statusRecebimentoRowChanging" msprop:Generator_RowEvArgName="statusRecebimentoRowChangeEvent" msprop:Generator_RowEvHandlerName="statusRecebimentoRowChangeEventHandler" msprop:Generator_TablePropName="statusRecebimento" msprop:Generator_TableVarName="tablestatusRecebimento" msprop:Generator_RowDeletingName="statusRecebimentoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:short" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipoGuia" msprop:Generator_UserTableName="tipoGuia" msprop:Generator_RowDeletedName="tipoGuiaRowDeleted" msprop:Generator_TableClassName="tipoGuiaDataTable" msprop:Generator_RowChangedName="tipoGuiaRowChanged" msprop:Generator_RowClassName="tipoGuiaRow" msprop:Generator_RowChangingName="tipoGuiaRowChanging" msprop:Generator_RowEvArgName="tipoGuiaRowChangeEvent" msprop:Generator_RowEvHandlerName="tipoGuiaRowChangeEventHandler" msprop:Generator_TablePropName="tipoGuia" msprop:Generator_TableVarName="tabletipoGuia" msprop:Generator_RowDeletingName="tipoGuiaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="tipoGuiaCod" msprop:Generator_UserColumnName="tipoGuiaCod" msprop:Generator_ColumnPropNameInRow="tipoGuiaCod" msprop:Generator_ColumnVarNameInTable="columntipoGuiaCod" msprop:Generator_ColumnPropNameInTable="tipoGuiaCodColumn" type="xs:short" />
              <xs:element name="tipoGuia" msprop:Generator_UserColumnName="tipoGuia" msprop:Generator_ColumnPropNameInRow="tipoGuia" msprop:Generator_ColumnVarNameInTable="columntipoGuia" msprop:Generator_ColumnPropNameInTable="tipoGuiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipoTransacao" msprop:Generator_UserTableName="tipoTransacao" msprop:Generator_RowDeletedName="tipoTransacaoRowDeleted" msprop:Generator_TableClassName="tipoTransacaoDataTable" msprop:Generator_RowChangedName="tipoTransacaoRowChanged" msprop:Generator_RowClassName="tipoTransacaoRow" msprop:Generator_RowChangingName="tipoTransacaoRowChanging" msprop:Generator_RowEvArgName="tipoTransacaoRowChangeEvent" msprop:Generator_RowEvHandlerName="tipoTransacaoRowChangeEventHandler" msprop:Generator_TablePropName="tipoTransacao" msprop:Generator_TableVarName="tabletipoTransacao" msprop:Generator_RowDeletingName="tipoTransacaoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="tipoCod" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="tipoCod" msprop:Generator_ColumnPropNameInRow="tipoCod" msprop:Generator_ColumnVarNameInTable="columntipoCod" msprop:Generator_ColumnPropNameInTable="tipoCodColumn" type="xs:int" />
              <xs:element name="tipoTransacao" msprop:Generator_UserColumnName="tipoTransacao" msprop:Generator_ColumnPropNameInRow="tipoTransacao" msprop:Generator_ColumnVarNameInTable="columntipoTransacao" msprop:Generator_ColumnPropNameInTable="tipoTransacaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tipoURL" msprop:Generator_UserTableName="tipoURL" msprop:Generator_RowDeletedName="tipoURLRowDeleted" msprop:Generator_TableClassName="tipoURLDataTable" msprop:Generator_RowChangedName="tipoURLRowChanged" msprop:Generator_RowClassName="tipoURLRow" msprop:Generator_RowChangingName="tipoURLRowChanging" msprop:Generator_RowEvArgName="tipoURLRowChangeEvent" msprop:Generator_RowEvHandlerName="tipoURLRowChangeEventHandler" msprop:Generator_TablePropName="tipoURL" msprop:Generator_TableVarName="tabletipoURL" msprop:Generator_RowDeletingName="tipoURLRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="tipoURL_cod" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="tipoURL_cod" msprop:Generator_ColumnPropNameInRow="tipoURL_cod" msprop:Generator_ColumnVarNameInTable="columntipoURL_cod" msprop:Generator_ColumnPropNameInTable="tipoURL_codColumn" type="xs:int" />
              <xs:element name="Descricao" msprop:Generator_UserColumnName="Descricao" msprop:Generator_ColumnPropNameInRow="Descricao" msprop:Generator_ColumnVarNameInTable="columnDescricao" msprop:Generator_ColumnPropNameInTable="DescricaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="35" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Trabalha" msprop:Generator_UserTableName="Trabalha" msprop:Generator_RowDeletedName="TrabalhaRowDeleted" msprop:Generator_TableClassName="TrabalhaDataTable" msprop:Generator_RowChangedName="TrabalhaRowChanged" msprop:Generator_RowClassName="TrabalhaRow" msprop:Generator_RowChangingName="TrabalhaRowChanging" msprop:Generator_RowEvArgName="TrabalhaRowChangeEvent" msprop:Generator_RowEvHandlerName="TrabalhaRowChangeEventHandler" msprop:Generator_TablePropName="Trabalha" msprop:Generator_TableVarName="tableTrabalha" msprop:Generator_RowDeletingName="TrabalhaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="codPrestador" msprop:Generator_UserColumnName="codPrestador" msprop:Generator_ColumnPropNameInRow="codPrestador" msprop:Generator_ColumnVarNameInTable="columncodPrestador" msprop:Generator_ColumnPropNameInTable="codPrestadorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="regANS" msprop:Generator_UserColumnName="regANS" msprop:Generator_ColumnPropNameInRow="regANS" msprop:Generator_ColumnVarNameInTable="columnregANS" msprop:Generator_ColumnPropNameInTable="regANSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="codnaOperadora" msprop:Generator_UserColumnName="codnaOperadora" msprop:Generator_ColumnPropNameInRow="codnaOperadora" msprop:Generator_ColumnVarNameInTable="columncodnaOperadora" msprop:Generator_ColumnPropNameInTable="codnaOperadoraColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Clin_Hosp" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="DemonstrativoRetorno_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DemonstrativoRetorno" />
      <xs:field xpath="mstns:demonstrativoCod" />
    </xs:unique>
    <xs:unique name="ExtensaoSolicProc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExtensaoSolicProc" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="guia_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:guia" />
      <xs:field xpath="mstns:numeroGuia" />
      <xs:field xpath="mstns:IDLote" />
    </xs:unique>
    <xs:unique name="guiaOutrasDespesas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:guiaOutrasDespesas" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="IntervaloLote_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IntervaloLote" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Login_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Login" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="LoteGuias_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LoteGuias" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Mensagem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Mensagem" />
      <xs:field xpath="mstns:sequencialTransacao" />
    </xs:unique>
    <xs:unique name="Operadora_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Operadora" />
      <xs:field xpath="mstns:regANS" />
    </xs:unique>
    <xs:unique name="OperadoraURLs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OperadoraURLs" />
      <xs:field xpath="mstns:regANS" />
      <xs:field xpath="mstns:tipoURL_cod" />
    </xs:unique>
    <xs:unique name="Prestador_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Prestador" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Profissional_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Profissional" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="SolicitacaoProcedimento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SolicitacaoProcedimento" />
      <xs:field xpath="mstns:numeroGuia" />
      <xs:field xpath="mstns:codPrestador" />
      <xs:field xpath="mstns:regANS" />
    </xs:unique>
    <xs:unique name="StatusProcFaturamento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StatusProcFaturamento" />
      <xs:field xpath="mstns:numeroGuia" />
      <xs:field xpath="mstns:IDLote" />
    </xs:unique>
    <xs:unique name="statusRecebimento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:statusRecebimento" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="tipoGuia_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipoGuia" />
      <xs:field xpath="mstns:tipoGuiaCod" />
    </xs:unique>
    <xs:unique name="tipoTransacao_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipoTransacao" />
      <xs:field xpath="mstns:tipoCod" />
    </xs:unique>
    <xs:unique name="tipoURL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tipoURL" />
      <xs:field xpath="mstns:tipoURL_cod" />
    </xs:unique>
    <xs:unique name="Trabalha_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Trabalha" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="PrestadorClin_Hosp" msdata:parent="Prestador" msdata:child="Clin_Hosp" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="PrestadorClin_Hosp" msprop:Generator_RelationVarName="relationPrestadorClin_Hosp" msprop:Generator_UserChildTable="Clin_Hosp" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetClin_HospRows" />
      <msdata:Relationship name="LoteGuiasDemonstrativoRetorno" msdata:parent="LoteGuias" msdata:child="DemonstrativoRetorno" msdata:parentkey="ID" msdata:childkey="loteID" msprop:Generator_UserRelationName="LoteGuiasDemonstrativoRetorno" msprop:Generator_RelationVarName="relationLoteGuiasDemonstrativoRetorno" msprop:Generator_UserChildTable="DemonstrativoRetorno" msprop:Generator_UserParentTable="LoteGuias" msprop:Generator_ParentPropName="LoteGuiasRow" msprop:Generator_ChildPropName="GetDemonstrativoRetornoRows" />
      <msdata:Relationship name="MensagemDemonstrativoRetorno" msdata:parent="Mensagem" msdata:child="DemonstrativoRetorno" msdata:parentkey="sequencialTransacao" msdata:childkey="SequencialTransacao" msprop:Generator_UserRelationName="MensagemDemonstrativoRetorno" msprop:Generator_RelationVarName="relationMensagemDemonstrativoRetorno" msprop:Generator_UserChildTable="DemonstrativoRetorno" msprop:Generator_UserParentTable="Mensagem" msprop:Generator_ParentPropName="MensagemRow" msprop:Generator_ChildPropName="GetDemonstrativoRetornoRows" />
      <msdata:Relationship name="OperadoraDemonstrativoRetorno" msdata:parent="Operadora" msdata:child="DemonstrativoRetorno" msdata:parentkey="regANS" msdata:childkey="regANS" msprop:Generator_UserRelationName="OperadoraDemonstrativoRetorno" msprop:Generator_RelationVarName="relationOperadoraDemonstrativoRetorno" msprop:Generator_UserChildTable="DemonstrativoRetorno" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetDemonstrativoRetornoRows" />
      <msdata:Relationship name="PrestadorDemonstrativoRetorno" msdata:parent="Prestador" msdata:child="DemonstrativoRetorno" msdata:parentkey="ID" msdata:childkey="codPrestador" msprop:Generator_UserRelationName="PrestadorDemonstrativoRetorno" msprop:Generator_RelationVarName="relationPrestadorDemonstrativoRetorno" msprop:Generator_UserChildTable="DemonstrativoRetorno" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetDemonstrativoRetornoRows" />
      <msdata:Relationship name="tipoGuiaDemonstrativoRetorno" msdata:parent="tipoGuia" msdata:child="DemonstrativoRetorno" msdata:parentkey="tipoGuiaCod" msdata:childkey="tipoSolic_Cod" msprop:Generator_UserRelationName="tipoGuiaDemonstrativoRetorno" msprop:Generator_RelationVarName="relationtipoGuiaDemonstrativoRetorno" msprop:Generator_UserChildTable="DemonstrativoRetorno" msprop:Generator_UserParentTable="tipoGuia" msprop:Generator_ParentPropName="tipoGuiaRow" msprop:Generator_ChildPropName="GetDemonstrativoRetornoRows" />
      <msdata:Relationship name="SolicitacaoProcedimentoExtensaoSolicProc" msdata:parent="SolicitacaoProcedimento" msdata:child="ExtensaoSolicProc" msdata:parentkey="numeroGuia regANS codPrestador" msdata:childkey="numeroGuia regANS codPrestador" msprop:Generator_UserRelationName="SolicitacaoProcedimentoExtensaoSolicProc" msprop:Generator_RelationVarName="relationSolicitacaoProcedimentoExtensaoSolicProc" msprop:Generator_UserChildTable="ExtensaoSolicProc" msprop:Generator_UserParentTable="SolicitacaoProcedimento" msprop:Generator_ParentPropName="SolicitacaoProcedimentoRowParent" msprop:Generator_ChildPropName="GetExtensaoSolicProcRows" />
      <msdata:Relationship name="LoteGuiasguia" msdata:parent="LoteGuias" msdata:child="guia" msdata:parentkey="ID" msdata:childkey="IDLote" msprop:Generator_UserRelationName="LoteGuiasguia" msprop:Generator_RelationVarName="relationLoteGuiasguia" msprop:Generator_UserChildTable="guia" msprop:Generator_UserParentTable="LoteGuias" msprop:Generator_ParentPropName="LoteGuiasRow" msprop:Generator_ChildPropName="GetguiaRows" />
      <msdata:Relationship name="guiaguiaOutrasDespesas" msdata:parent="guia" msdata:child="guiaOutrasDespesas" msdata:parentkey="numeroGuia IDLote" msdata:childkey="numeroGuia IDLote" msprop:Generator_UserRelationName="guiaguiaOutrasDespesas" msprop:Generator_RelationVarName="relationguiaguiaOutrasDespesas" msprop:Generator_UserChildTable="guiaOutrasDespesas" msprop:Generator_UserParentTable="guia" msprop:Generator_ParentPropName="guiaRowParent" msprop:Generator_ChildPropName="GetguiaOutrasDespesasRows" />
      <msdata:Relationship name="TrabalhaIntervaloLote" msdata:parent="Trabalha" msdata:child="IntervaloLote" msdata:parentkey="ID" msdata:childkey="IDTrabalha" msprop:Generator_UserRelationName="TrabalhaIntervaloLote" msprop:Generator_RelationVarName="relationTrabalhaIntervaloLote" msprop:Generator_UserChildTable="IntervaloLote" msprop:Generator_UserParentTable="Trabalha" msprop:Generator_ParentPropName="TrabalhaRow" msprop:Generator_ChildPropName="GetIntervaloLoteRows" />
      <msdata:Relationship name="PrestadorLogin" msdata:parent="Prestador" msdata:child="Login" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="PrestadorLogin" msprop:Generator_RelationVarName="relationPrestadorLogin" msprop:Generator_UserChildTable="Login" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetLoginRows" />
      <msdata:Relationship name="MensagemLoteGuias" msdata:parent="Mensagem" msdata:child="LoteGuias" msdata:parentkey="sequencialTransacao" msdata:childkey="sequencialTransacao" msprop:Generator_UserRelationName="MensagemLoteGuias" msprop:Generator_RelationVarName="relationMensagemLoteGuias" msprop:Generator_UserChildTable="LoteGuias" msprop:Generator_UserParentTable="Mensagem" msprop:Generator_ParentPropName="MensagemRow" msprop:Generator_ChildPropName="GetLoteGuiasRows" />
      <msdata:Relationship name="OperadoraLoteGuias" msdata:parent="Operadora" msdata:child="LoteGuias" msdata:parentkey="regANS" msdata:childkey="regANS" msprop:Generator_UserRelationName="OperadoraLoteGuias" msprop:Generator_RelationVarName="relationOperadoraLoteGuias" msprop:Generator_UserChildTable="LoteGuias" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetLoteGuiasRows" />
      <msdata:Relationship name="PrestadorLoteGuias" msdata:parent="Prestador" msdata:child="LoteGuias" msdata:parentkey="ID" msdata:childkey="codPrestador" msprop:Generator_UserRelationName="PrestadorLoteGuias" msprop:Generator_RelationVarName="relationPrestadorLoteGuias" msprop:Generator_UserChildTable="LoteGuias" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetLoteGuiasRows" />
      <msdata:Relationship name="statusRecebimentoLoteGuias" msdata:parent="statusRecebimento" msdata:child="LoteGuias" msdata:parentkey="ID" msdata:childkey="codStatusRecebimento" msprop:Generator_UserRelationName="statusRecebimentoLoteGuias" msprop:Generator_RelationVarName="relationstatusRecebimentoLoteGuias" msprop:Generator_UserChildTable="LoteGuias" msprop:Generator_UserParentTable="statusRecebimento" msprop:Generator_ParentPropName="statusRecebimentoRow" msprop:Generator_ChildPropName="GetLoteGuiasRows" />
      <msdata:Relationship name="tipoGuiaLoteGuias" msdata:parent="tipoGuia" msdata:child="LoteGuias" msdata:parentkey="tipoGuiaCod" msdata:childkey="tipoGuia" msprop:Generator_UserRelationName="tipoGuiaLoteGuias" msprop:Generator_RelationVarName="relationtipoGuiaLoteGuias" msprop:Generator_UserChildTable="LoteGuias" msprop:Generator_UserParentTable="tipoGuia" msprop:Generator_ParentPropName="tipoGuiaRow" msprop:Generator_ChildPropName="GetLoteGuiasRows" />
      <msdata:Relationship name="OperadoraMensagem" msdata:parent="Operadora" msdata:child="Mensagem" msdata:parentkey="regANS" msdata:childkey="destino" msprop:Generator_UserRelationName="OperadoraMensagem" msprop:Generator_RelationVarName="relationOperadoraMensagem" msprop:Generator_UserChildTable="Mensagem" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetMensagemRows" />
      <msdata:Relationship name="PrestadorMensagem" msdata:parent="Prestador" msdata:child="Mensagem" msdata:parentkey="ID" msdata:childkey="origem" msprop:Generator_UserRelationName="PrestadorMensagem" msprop:Generator_RelationVarName="relationPrestadorMensagem" msprop:Generator_UserChildTable="Mensagem" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetMensagemRows" />
      <msdata:Relationship name="tipoTransacaoMensagem" msdata:parent="tipoTransacao" msdata:child="Mensagem" msdata:parentkey="tipoCod" msdata:childkey="tipoCod" msprop:Generator_UserRelationName="tipoTransacaoMensagem" msprop:Generator_RelationVarName="relationtipoTransacaoMensagem" msprop:Generator_UserChildTable="Mensagem" msprop:Generator_UserParentTable="tipoTransacao" msprop:Generator_ParentPropName="tipoTransacaoRow" msprop:Generator_ChildPropName="GetMensagemRows" />
      <msdata:Relationship name="OperadoraOperadoraURLs" msdata:parent="Operadora" msdata:child="OperadoraURLs" msdata:parentkey="regANS" msdata:childkey="regANS" msprop:Generator_UserRelationName="OperadoraOperadoraURLs" msprop:Generator_RelationVarName="relationOperadoraOperadoraURLs" msprop:Generator_UserChildTable="OperadoraURLs" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetOperadoraURLsRows" />
      <msdata:Relationship name="tipoURLOperadoraURLs" msdata:parent="tipoURL" msdata:child="OperadoraURLs" msdata:parentkey="tipoURL_cod" msdata:childkey="tipoURL_cod" msprop:Generator_UserRelationName="tipoURLOperadoraURLs" msprop:Generator_RelationVarName="relationtipoURLOperadoraURLs" msprop:Generator_UserChildTable="OperadoraURLs" msprop:Generator_UserParentTable="tipoURL" msprop:Generator_ParentPropName="tipoURLRow" msprop:Generator_ChildPropName="GetOperadoraURLsRows" />
      <msdata:Relationship name="PrestadorProfissional" msdata:parent="Prestador" msdata:child="Profissional" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="PrestadorProfissional" msprop:Generator_RelationVarName="relationPrestadorProfissional" msprop:Generator_UserChildTable="Profissional" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetProfissionalRows" />
      <msdata:Relationship name="MensagemSolicitacaoProcedimento" msdata:parent="Mensagem" msdata:child="SolicitacaoProcedimento" msdata:parentkey="sequencialTransacao" msdata:childkey="sequencialTransacao" msprop:Generator_UserRelationName="MensagemSolicitacaoProcedimento" msprop:Generator_RelationVarName="relationMensagemSolicitacaoProcedimento" msprop:Generator_UserChildTable="SolicitacaoProcedimento" msprop:Generator_UserParentTable="Mensagem" msprop:Generator_ParentPropName="MensagemRow" msprop:Generator_ChildPropName="GetSolicitacaoProcedimentoRows" />
      <msdata:Relationship name="OperadoraSolicitacaoProcedimento" msdata:parent="Operadora" msdata:child="SolicitacaoProcedimento" msdata:parentkey="regANS" msdata:childkey="regANS" msprop:Generator_UserRelationName="OperadoraSolicitacaoProcedimento" msprop:Generator_RelationVarName="relationOperadoraSolicitacaoProcedimento" msprop:Generator_UserChildTable="SolicitacaoProcedimento" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetSolicitacaoProcedimentoRows" />
      <msdata:Relationship name="PrestadorSolicitacaoProcedimento" msdata:parent="Prestador" msdata:child="SolicitacaoProcedimento" msdata:parentkey="ID" msdata:childkey="codPrestador" msprop:Generator_UserRelationName="PrestadorSolicitacaoProcedimento" msprop:Generator_RelationVarName="relationPrestadorSolicitacaoProcedimento" msprop:Generator_UserChildTable="SolicitacaoProcedimento" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetSolicitacaoProcedimentoRows" />
      <msdata:Relationship name="statusRecebimentoSolicitacaoProcedimento" msdata:parent="statusRecebimento" msdata:child="SolicitacaoProcedimento" msdata:parentkey="ID" msdata:childkey="codStatusRecebimento" msprop:Generator_UserRelationName="statusRecebimentoSolicitacaoProcedimento" msprop:Generator_RelationVarName="relationstatusRecebimentoSolicitacaoProcedimento" msprop:Generator_UserChildTable="SolicitacaoProcedimento" msprop:Generator_UserParentTable="statusRecebimento" msprop:Generator_ParentPropName="statusRecebimentoRow" msprop:Generator_ChildPropName="GetSolicitacaoProcedimentoRows" />
      <msdata:Relationship name="tipoGuiaSolicitacaoProcedimento" msdata:parent="tipoGuia" msdata:child="SolicitacaoProcedimento" msdata:parentkey="tipoGuiaCod" msdata:childkey="tipoSolic_cod" msprop:Generator_UserRelationName="tipoGuiaSolicitacaoProcedimento" msprop:Generator_RelationVarName="relationtipoGuiaSolicitacaoProcedimento" msprop:Generator_UserChildTable="SolicitacaoProcedimento" msprop:Generator_UserParentTable="tipoGuia" msprop:Generator_ParentPropName="tipoGuiaRow" msprop:Generator_ChildPropName="GetSolicitacaoProcedimentoRows" />
      <msdata:Relationship name="guiaStatusProcedimento" msdata:parent="guia" msdata:child="StatusProcFaturamento" msdata:parentkey="numeroGuia IDLote" msdata:childkey="numeroGuia IDLote" msprop:Generator_UserRelationName="guiaStatusProcedimento" msprop:Generator_RelationVarName="relationguiaStatusProcedimento" msprop:Generator_UserChildTable="StatusProcFaturamento" msprop:Generator_UserParentTable="guia" msprop:Generator_ParentPropName="guiaRowParent" msprop:Generator_ChildPropName="GetStatusProcFaturamentoRows" />
      <msdata:Relationship name="OperadoraTrabalha" msdata:parent="Operadora" msdata:child="Trabalha" msdata:parentkey="regANS" msdata:childkey="regANS" msprop:Generator_UserRelationName="OperadoraTrabalha" msprop:Generator_RelationVarName="relationOperadoraTrabalha" msprop:Generator_UserChildTable="Trabalha" msprop:Generator_UserParentTable="Operadora" msprop:Generator_ParentPropName="OperadoraRow" msprop:Generator_ChildPropName="GetTrabalhaRows" />
      <msdata:Relationship name="PrestadorTrabalha" msdata:parent="Prestador" msdata:child="Trabalha" msdata:parentkey="ID" msdata:childkey="codPrestador" msprop:Generator_UserRelationName="PrestadorTrabalha" msprop:Generator_RelationVarName="relationPrestadorTrabalha" msprop:Generator_UserChildTable="Trabalha" msprop:Generator_UserParentTable="Prestador" msprop:Generator_ParentPropName="PrestadorRow" msprop:Generator_ChildPropName="GetTrabalhaRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>